USE [NuevoConsultorioSQL]
GO

/****** Object:  Table [dbo].[DatosMedicos]    Script Date: 03/07/2009 14:42:36 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[nDatosMedicos](
	[codMedico] [uniqueidentifier] NOT NULL,
	[codMedicoAnterior] [int] NOT NULL,
	[Matricula] [nvarchar](20) NULL,
	[Especialidad] [nvarchar](30) NULL,
	[Activo] [bit] NOT NULL)

GO
ALTER TABLE [dbo].[nDatosMedicos] ADD  DEFAULT (newid()) FOR [codMedico]
GO

ALTER TABLE [dbo].[nDatosMedicos] ADD  DEFAULT ('-') FOR [Especialidad]
GO

ALTER TABLE [dbo].[nDatosMedicos] ADD  DEFAULT ((1)) FOR [Activo]
GO


